import { app, shell, BrowserWindow, ipcMain, dialog } from "electron";
import { join } from "path";
import { electronApp, optimizer, is } from "@electron-toolkit/utils";
import icon from "../../resources/icon.png?asset";
import { DataSource } from "typeorm";
import fs from "fs";
import path from "path";

function createWindow(): void {
  const preload = join(__dirname, "../preload/index.js");
  console.log("preload", preload);
  // Create the browser window.
  const mainWindow = new BrowserWindow({
    width: 900,
    height: 670,
    minWidth: 870,
    minHeight: 600,
    show: false,
    autoHideMenuBar: true,
    ...(process.platform === "linux" ? { icon } : {}),
    webPreferences: {
      preload,
      sandbox: false,
    },
  });

  mainWindow.on("ready-to-show", () => {
    mainWindow.show();
    console.log("mainWindow", mainWindow["fsApi"]);
  });

  mainWindow.webContents.setWindowOpenHandler((details) => {
    shell.openExternal(details.url);
    return { action: "deny" };
  });

  // HMR for renderer base on electron-vite cli.
  // Load the remote URL for development or the local html file for production.
  if (is.dev && process.env["ELECTRON_RENDERER_URL"]) {
    mainWindow.loadURL(process.env["ELECTRON_RENDERER_URL"]);
  } else {
    mainWindow.loadFile(join(__dirname, "../renderer/index.html"));
  }
}

let config: any = {}
let myDataSource: DataSource | null = null;

const dataSource = async () => {
  if (!myDataSource) {
    const c = { ...config }
    if (c.type === "mysql") {
      c.driver = require("mysql2");
    }
    myDataSource = new DataSource(c);
    await myDataSource.initialize();
  }
  return myDataSource
}


// This method will be called when Electron has finished
// initialization and is ready to create browser windows.
// Some APIs can only be used after this event occurs.
app.whenReady().then(() => {
  // Set app user model id for windows
  electronApp.setAppUserModelId("org.jadedrip.data-querier");

  // 打开配置文件
  try {
    config = JSON.parse(fs.readFileSync("config.json", "utf-8"));
  } catch (e) {

    config = {
      type: "mysql",
      host: "localhost",
      port: 3306,
      username: "",
      password: "",
      database: "",
      path: ""
    }
  }

  ipcMain.handle("getFiles", async () => {
    if (!config.path) throw new Error("未配置路径");
    return fs.readdirSync(config.path).map(f => path.join(config.path, f));
  });

  ipcMain.handle("executeQuery", async (_, sql: string) => {
    const ds = await dataSource();
    if (!ds) throw new Error("未配置数据库");
    return ds.query(sql);
  });

  ipcMain.handle("selectPath", async (_, defaultPath: string) => {
    const folderPaths = dialog.showOpenDialogSync({
      defaultPath,
      properties: ['openDirectory']
    });
    return folderPaths;
  })

  ipcMain.handle("setConfig", (_, c: string) => {
    config = JSON.parse(c)
    fs.writeFileSync("config.json", c);
    if (myDataSource) {
      myDataSource.destroy()
      myDataSource = null
    }
  })

  ipcMain.handle("getConfig", () => {
    return config;
  })

  // Default open or close DevTools by F12 in development
  // and ignore CommandOrControl + R in production.
  // see https://github.com/alex8088/electron-toolkit/tree/master/packages/utils
  app.on("browser-window-created", (_, window) => {
    optimizer.watchWindowShortcuts(window);
  });

  // IPC test
  ipcMain.on("ping", () => console.log("pong"));

  createWindow();

  app.on("activate", function () {
    // On macOS it's common to re-create a window in the app when the
    // dock icon is clicked and there are no other windows open.
    if (BrowserWindow.getAllWindows().length === 0) createWindow();
  });
});

// Quit when all windows are closed, except on macOS. There, it's common
// for applications and their menu bar to stay active until the user quits
// explicitly with Cmd + Q.
app.on("window-all-closed", () => {
  if (process.platform !== "darwin") {
    app.quit();
  }
});

// In this file you can include the rest of your app"s specific main process
// code. You can also put them in separate files and require them here.
